You are here: Building the Model: Advanced Elements > Arrays > Import Data into Arrays > Import from a SQL Database
Connection String The connection string used to connect to the SQL database including all necessary security parameters.
Query or Stored Procedure Enter the SQL query or the name of the stored procedure to be executed during the model’s initialization logic to populate the array.
How to import SQL database data into array:
1. Select Arrays from the Build menu.
2. Select or create the array record (row) you wish to import.
3. Click the Import File button on the Arrays dialog.
4. Click on the Database radio button.
5. In the Connection String field enter the necessary string to connect to the desired database.
6. In the Query or Stored Procedure field enter the SQL query or stored Procedure name that will be used to populate the array during the initialization logic.
7. Click OK.